CREATING SLICERS & Last Refresh 13

Adding date slicer

Ø  Open Visualization pane

Ø  Select Slicer visual

Ø  Drag the visual to the dashboard.

Ø  Click on Date table and drag Year column and place it inside the field.

Ø  General: X - Position = 910, Y - Position = 10, Width = 185 and Height = 71

Ø  Slider Header = Off

Ø  Numeric inputs: Font color = #FFFFFF, Text size = 9, Font family = Segoe UI

Ø  Slider  = On: Color = #CCCCCC

Ø  Title = Off

GIF 1



GIF 2


GIF 3


Adding Class Instructor slicer

Ø  Open Visualization pane

Ø  Select Slicer visual

Ø  Drag the visual to the dashboard.

Ø  Click on 'vw_QS_MetricsDashboard_ClassManagement' table and drag 'Class_ClassInstructor' and place it inside the field.

Ø  General: X - Position = 10, Y - Position = 409, Width = 197 and Height = 102

Ø  Slider Header = Off

Ø  Title = On: Title text = Class Instructor: Font Color: #FFFFFF: Background Color: #596DBD: Alignment = Center: Text size = 15: Font Family = Cambria Math

Ø  Border = On: Color = #B3B3B3


GIF


Adding Section Name slicer

Ø  Open Visualization pane

Ø  Select Slicer visual

Ø  Drag the visual to the dashboard.

Ø  Click on 'vw_QS_MetricsDashboard_ClassManagement' table and drag 'Click on 'vw_QS_MetricsDashboard_ClassManagement' table and drag 'Class_SectionName' column from and place it inside the field.

Ø  General: X - Position = 10, Y - Position = 409, Width = 197 and Height = 102

Ø  Slider Header = Off

Ø  Title = On: Title text = Section Name: Font Color: #FFFFFF: Background Color: #596DBD: Alignment = Center: Text size = 15: Font Family = Cambria Math

Ø  Border = On: Color = #B3B3B3



Adding Refresh Visual

Ø  Open Visualization pane

Ø  Select Card visual

Ø  Drag the visual to the dashboard.

Ø  Click on Last Refresh table and drag 'LastRefresh' column and place it inside the field.

Ø  General: X - Position = 10, Y - Position = 612, Width = 197 and Height = 107

Ø  Data Label:  Text size = 27: Font Family = DIN

Ø  Category = Off

Ø  Word wrap = On

Ø  Title = On: Title text = Last Refresh: Font Color: #FFFFFF: Background Color: #596DBD: Alignment = Center: Text size = 15: Font Family = Cambria Math

Ø  Border  = On: Color = #B3B3B3

Ø  Title = Off


GIF


Dashboard should look like this 



Use the link below creating slicers in power bi:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers